use "C:\Users\awcassidy1\Dropbox\jmp_new\cleaned_data/estimation_temp.dta", clear

la var pool "Pool"

********************************************************************************
*Summary statistics
********************************************************************************
preserve
keep if !missing(pricediff)
local auditvars waterheaterfueltype waterheatertanktype atticrvalue furnacefueltype ///
	eeravg negleakavg ///
	rsavg ductravg negsysageavg ///
	  ductsystem1type sizeavg ///
	progtherm system1locationairhandler system1airhandlertype

eststo clear

qui estpost sum pricediff an_pd  laggedprice price lsaleyear saleyear  ///
	 `auditvars' conditionedsqft sqfttotal num_beds_total ///
	 num_baths_total yearbuiltaudit ///
	 atticsqft austinelec_adj1 austinelec_adj2 texasgas_adj1 texasgas_adj2

esttab using "C:\Users\awcassidy1\Dropbox\jmp_new/tables/bigsumtableld.tex", fragment replace ///
	cells((mean(label(\multicolumn{1}{c}{}) fmt(2)) ///
	sd(label(\multicolumn{1}{c}{}) fmt(2)) ///
	min(label(\multicolumn{1}{c}{}) fmt(2)) ///
	max(label(\multicolumn{1}{c}{}) fmt(2)) ///
	count(label(\multicolumn{1}{c}{}) fmt(0)))) ///
	label booktabs nonum noobs ///
	nolines nomtitles
	
restore



